-- ==================================================
-- Author:杨洁(kaixuanpisces)
-- Create date: 20090729
-- Description:	创建数据库
-- =============================================

if exists (select * from sysdatabases where name = 'HR_DB')
   drop database HR_DB
go

create database "HR_DB" 
ON PRIMARY
	 ( NAME = hr_db, FILENAME = 'hr_db.mdf', SIZE = 3 MB, MAXSIZE = UNLIMITED, FILEGROWTH = 256 KB )
LOG ON
	 ( NAME = hr_log, FILENAME = 'hr_log.ldf', SIZE = 1 MB, MAXSIZE = UNLIMITED, FILEGROWTH = 256 KB )  

go

use "HR_DB"  

go